﻿-- G8 https://en.wikipedia.org/wiki/G8
SELECT * FROM common.Country WHERE NAME LIKE 'FRANCE'
UNION SELECT * FROM common.Country WHERE NAME LIKE 'GERMANY'
UNION SELECT * FROM common.Country WHERE NAME LIKE 'ITALY'
UNION SELECT * FROM common.Country WHERE NAME LIKE 'JAPAN'
UNION SELECT * FROM common.Country WHERE NAME LIKE 'UNITED KINGDOM'
UNION SELECT * FROM common.Country WHERE NAME LIKE 'UNITED STATES'
UNION SELECT * FROM common.Country WHERE NAME LIKE 'CANADA'
UNION SELECT * FROM common.Country WHERE NAME LIKE 'RUSSIAN FEDERATION'

/*
The Group of Eight (G8) is a forum for the governments of the world's eight wealthiest countries. 
The forum originated with a 1975 summit hosted by France that brought together representatives of six governments: 
France, Germany, Italy, Japan, the United Kingdom, and the United States, thus leading to the name Group of Six or G6. 

The summit became known as the Group of Seven or G7 the following year with the addition of Canada. 
The G7, that is active even after the creation of the G8, is composed by the 7 wealthiest countries on Earth 
(as net wealth and not GDP). 

In 1997, Russia was added to the group which then became known as the G8.
The European Union is represented within the G8 but cannot host or chair summits.
*/
